Set Range Colour

AutomatR.Excel.Activities.SetRangeColor

The "Set Range Color" activity in AutomatR is part of the Excel activities package, allowing users to change the background color of a specified cell or cell range within an Excel spreadsheet. This activity enhances the visual representation of data and facilitates the customization of Excel sheets in automation workflows.

NOTE: This activity can only be used in Excel Root activity.

Properties

Name	Description
Input
Color	Enter the color to fill the background for the specified range in the sheet. This can be a known color name (e.g., "Red"). String variables containing the color name.
Hex Color	Enter the hex color to fill the background for the specified range in the sheet. String variables containing the hex color code (e.g., "#FF0000" for red).
Range	Enter the range which needs to be filled with color. This should be in the format of Excel range, such as "A1:B5". String variables containing the desired range.
Misc
Display Name	The display name of the activity. A display name is automatically generated when you indicate a target.
Optional
Delay	Enter the wait time in seconds (Example: 5 seconds i.e., 5) to start the activity. Integer variables containing the delay duration.

How to use:

1. Drag and drop the "Set Range Color" activity onto the workflow.
2. Configure the properties by specifying the range and color (either Hex Color or Color).
3. Optionally, configure the delay.
4. Execute the workflow to change the background color of the specified range within the Excel spreadsheet.

Important:

• Ensure that the Excel workbook and sheet are open and accessible.
• The specified range should be in a valid Excel range format (e.g., "A1:B5").
• The color can be specified either in hex format (Hex Color) or by using a known color name (Color).
• Incorrect range formats may result in an "Invalid given range" error.
• Incorrect color specifications may result in an "Invalid color name" or "Incorrect hexadecimal code" error.